{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Invoerblad","Uitslagformulier"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoerblad","index":0,"n_rows":99,"n_cols":53,"rows_kept":99,"cut":false,"hidden":false,"merged":[[33,1,33,2],[26,15,26,17],[16,1,16,2],[8,1,9,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[20,15,20,17],[21,1,21,2],[22,1,22,2],[32,1,32,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[4,31,4,33],[15,0,15,1],[0,5,0,7],[1,5,1,7],[2,5,2,7],[3,5,3,7],[5,4,5,7],[5,0,5,3],[10,15,10,17],[15,15,15,17],[6,8,6,9],[8,0,9,0],[7,0,7,1],[38,9,38,11],[10,2,10,4],[11,2,11,4],[12,2,12,4],[0,2,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[7,8,7,9],[34,1,34,2],[35,1,35,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2]]}
[null,null,"Voorronde PK:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Data:"]
[null,null,"Locatie:"]
[null,null,"Wedstrijdleider:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schema 3 personen"]
["NAMEN INVULLEN VOLGORDE UITNODIGING",null,null,null,"UITSLUITEND DE GELE VLAKKEN INVULLEN !",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",2]
[null,null,null,null,null,null,null,null,"Max. beurten:",null,60,"Brt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"-",3]
["Deelnemers",null,null,null,null,null,null,null,"Te spelen partijen:",null,4,"Parijen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",3]
["Bondsnr","Naam",null,"Vereniging",null,"te maken","aanvangs","Oficieel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",2]
[null,null,null,null,null,"car.","moy.","moyenne",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"-",3]
[null," ",null,null,null,null," "," ",null,null,null,null,null,null,null,"aantal partijen gespeeld",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"-",3]
[null," ",null,null,null,null," "," ",null,null,null,null,null,1,{"$f":"IF(E18>0,1,FALSE)","v":1},{"$f":"IF(E24>0,1,FALSE)","v":1},{"$f":"IF(E29>0,1,FALSE)","v":1},{"$f":"IF(E35>0,1,FALSE)","v":1},{"$f":"SUM(O12:R12)","v":4},{"$f":"PRODUCT(F11,S12)","v":4}]
[null," ",null,null,null,null," "," ",null,null,null,null,null,"HJ22",{"$f":"IF(E19>0,1,FALSE)","v":1},{"$f":"IF(E21>0,1,FALSE)","v":1},{"$f":"IF(E30>0,1,FALSE)","v":1},{"$f":"IF(E32>0,1,FALSE)","v":1},{"$f":"SUM(O13:R13)","v":4},{"$f":"PRODUCT(F12,S13)","v":4}]
[null," ",null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(E22>0,1,FALSE)","v":1},{"$f":"IF(E25>0,1,FALSE)","v":1},{"$f":"IF(E33>0,1,FALSE)","v":1},{"$f":"IF(E36>0,1,FALSE)","v":1},{"$f":"SUM(O14:R14)","v":4},4]
[]
["Wedstrijden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% moyenne",null,null,null,null,null,null,null,null,"Partij","Car %",null,"Interval pnt. bij max. brt."]
[null,"Naam",null,"Car.","Brt.","HS","Moy.","Pnt.",null,null,null,null,null,1,{"$f":"IF(H18>0,G18,0)","v":0},{"$f":"IF(H24>0,G24,0)","v":0},{"$f":"IF(H29>0,G29,0)","v":0},{"$f":"IF(H35>0,G35,0)","v":0},{"$f":"MAX(O17:R17)","v":0}]
[null,{"$f":"B11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(D18/E18,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E18=K7,D18<F11,D19<F12),AC18,      IF(AND(D18=F11,D19<F12),2,IF(AND(D18=F11,D19=F12),1,0)))","v":0},null,null,null,null,null,2,{"$f":"IF(H19>0,G19,0)","v":0},{"$f":"IF(H21>0,G21,0)","v":0},{"$f":"IF(H30>0,G30,0)","v":0},{"$f":"IF(H32>0,G32,0)","v":0},{"$f":"MAX(O18:R18)","v":0},null,{"$f":"IF(D18=H11,1,0)","v":1},{"$f":"IF(D19<H12,1,0)","v":0},{"$f":"SUM(U18:V18)","v":1},null,1,{"$f":"ROUNDDOWN(D18/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D19/F12,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z18<AB18,0,IF(Z18>AB18,2,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB18<Z18,0,IF(AB18>Z18,2,1))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B12","v":" "},null," ",{"$f":"E18","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E18=K7,D19<F12,D18<F11),AD18,      IF(AND(D19=F12,D18<F11),2,IF(AND(D19=F12,D18=F11),1,0)))","v":0},null,null,null,null,null,3,{"$f":"IF(H22>0,G22,0)","v":0},{"$f":"IF(H25>0,G25,0)","v":0},{"$f":"IF(H33>0,G33,0)","v":0},{"$f":"IF(H36>0,G36,0)","v":0},0,null,{"$f":"IF(D19=H12,1,0)","v":1},{"$f":"IF(D18<H11,1,0)","v":0},{"$f":"SUM(U19:V19)","v":1},null,2,{"$f":"ROUNDDOWN(D21/F12,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D22/F13,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z19<AB19,0,IF(Z19>AB19,2,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB19<Z19,0,IF(AB19>Z19,2,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"ROUNDDOWN(D24/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D25/F13,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z20<AB20,0,IF(Z20>AB20,2,1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"B12","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(D21/E21,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E21=K7,D21<F12,D22<F13),AC19,      IF(AND(D21=F12,D22<F13),2,IF(AND(D21=F12,D22=F13),1,0)))","v":0},null,null,null,null,null,null,null,"partijen gewonnen",null,null,null,null,{"$f":"IF(D21=H12,1,0)","v":1},{"$f":"IF(D22<H13,1,0)","v":0},{"$f":"SUM(U21:V21)","v":1},null,4,{"$f":"ROUNDDOWN(D29/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D30/F12,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"B13","v":" "},null," ",{"$f":"E21","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E22=K7,D22<F13,D21<F12),AD19,         IF(AND(D22=F13,D21<F12),2,IF(AND(D22=F13,D21=F12),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D22=H13,1,0)","v":1},{"$f":"IF(D21<H12,1,0)","v":0},1,null,5,{"$f":"ROUNDDOWN(D32/F12,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D33/F13,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(H18>1,1,0)","v":0},{"$f":"IF(H24>1,1,0)","v":0},{"$f":"IF(H29>1,1,0)","v":0},{"$f":"IF(H35>1,1,0)","v":0},{"$f":"SUM(O23:R23)","v":0},null,null,null,null,null,6,{"$f":"ROUNDDOWN(D35/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D36/F13,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"B11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(D24/E24,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E24=K7,D24<F11,D25<F13),AC20,      IF(AND(D24=F11,D25<F13),2,IF(AND(D24=F11,D25=F13),1,0)))","v":0},null,null,null,null,null,2,{"$f":"IF(H19>1,1,0)","v":0},{"$f":"IF(H21>1,1,0)","v":0},{"$f":"IF(H30>1,1,0)","v":0},{"$f":"IF(H32>1,1,0)","v":0},{"$f":"SUM(O24:R24)","v":0},null,{"$f":"IF(D24=H11,1,0)","v":1},{"$f":"IF(D25<H13,1,0)","v":0},1]
[null,{"$f":"B13","v":" "},null," ",{"$f":"E24","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E25=K7,D25<F13,D24<F11),AD20,         IF(AND(D25=F13,D24<F11),2,IF(AND(D25=F13,D24=F11),1,0)))","v":0},null,null,null,null,null,3,{"$f":"IF(H22>1,1,0)","v":0},{"$f":"IF(H25>1,1,0)","v":0},{"$f":"IF(H33>1,1,0)","v":0},{"$f":"IF(H36>1,1,0)","v":0},{"$f":"SUM(O25:R25)","v":0},null,{"$f":"IF(D25=H13,1,0)","v":1},{"$f":"IF(D24<H11,1,0)","v":0},1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partijen gelijk"]
[null,"Naam",null,"Car.","Brt.","Hs","Moy.","Pnt."]
[null,null,null," "," "," ",{"$f":"ROUNDDOWN(D29/E29,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E29=K7,D29<F11,D30<F12),AC21,      IF(AND(D29=F11,D30<F12),2,IF(AND(D29=F11,D30=F12),1,0)))","v":0},null,null,null,null,null,1,{"$f":"IF(H18=1,1,0)","v":0},{"$f":"IF(H24=1,1,0)","v":0},{"$f":"IF(H35=1,1,0)","v":0},{"$f":"IF(H35=1,1,0)","v":0},{"$f":"SUM(O29:R29)","v":0},null,{"$f":"IF(D29=H11,1,0)","v":1},{"$f":"IF(D30<H12,1,0)","v":0},1]
[null,{"$f":"B12","v":" "},null," ",{"$f":"E29","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E30=K7,D30<F12,D29<F11),AD21,         IF(AND(D30=F12,D29<F11),2,IF(AND(D30=F12,D29=F11),1,0)))","v":0},null,null,null,null,null,2,{"$f":"IF(H19=1,1,0)","v":0},{"$f":"IF(H21=1,1,0)","v":0},{"$f":"IF(H30=1,1,0)","v":0},{"$f":"IF(H32=1,1,0)","v":0},{"$f":"SUM(O30:R30)","v":0},null,{"$f":"IF(D30=H12,1,0)","v":1},{"$f":"IF(D29<H11,1,0)","v":0},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(H22=1,1,0)","v":0},{"$f":"IF(H25=1,1,0)","v":0},{"$f":"IF(H33=1,1,0)","v":0},{"$f":"IF(H36=1,1,0)","v":0},{"$f":"SUM(O31:R31)","v":0}]
[null,{"$f":"B12","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(D32/E32,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E32=K7,D32<F12,D33<F13),AC22,      IF(AND(D32=F12,D33<F13),2,IF(AND(D32=F12,D33=F13),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32=H12,1,0)","v":1},{"$f":"IF(D33<H13,1,0)","v":0},{"$f":"SUM(U32:V32)","v":1}]
[null,{"$f":"B13","v":" "},null," ",{"$f":"E32","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E33=K7,D33<F13,D32<F12),AD22,         IF(AND(D33=F13,D32<F12),2,IF(AND(D33=F13,D32=F12),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D33=H13,1,0)","v":1},{"$f":"IF(D32<H12,1,0)","v":0},1]
[]
[null,{"$f":"B11","v":" "},null," "," "," ",{"$f":"ROUNDDOWN(D35/E35,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E35=K7,D35<F11,D36<F13),AC23,      IF(AND(D35=F11,D36<F13),2,IF(AND(D35=F11,D36=F13),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D35=H11,1,0)","v":1},{"$f":"IF(D36<H13,1,0)","v":0},1]
[null,{"$f":"B13","v":" "},null," ",{"$f":"E35","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E36=K7,D36<F13,D35<F11),AD23,      IF(AND(D36=F13,D35<F11),2,IF(AND(D36=F13,D35=F11),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D36=H13,1,0)","v":1},{"$f":"IF(D35<H11,1,0)","v":0},1]
[]
[]
["Stand",null,null,null,null,null,null,null,null,"Plaatsing ",null,null,"Rangking"]
[null,null,"Car.","Brt.","HS","Moy.","Pnt.","% moy.","% carb.","Mp.","% moy.","% carb."]
[null,{"$f":"B11","v":" "},{"$f":"SUM(D18,D24,D29,D35)","v":0},{"$f":"SUM(E18,E24,E29,E35)","v":0},{"$f":"MAX(F18,F24,F29,F35)","v":0},{"$f":"ROUNDDOWN(C41/D41,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H18,H24,H29,H35)","v":0},{"$f":"IF(OR(ISBLANK(C41),ISBLANK(D41)),\"-\",IF(AND(H11=\"NEE\",F41/G11>1),1,ROUNDDOWN(F41/G11,5)))","v":{"$error":"#DIV/0!"}},{"$f":"C41/T12","v":0},null,null,null,{"$f":"SUM(J41:L41)","v":0}]
[null,{"$f":"B12","v":" "},{"$f":"SUM(D19,D21,D30,D32)","v":0},{"$f":"SUM(E19,E21,E30,E32)","v":0},{"$f":"MAX(F19,F21,F30,F32)","v":0},{"$f":"ROUNDDOWN(C42/D42,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H19,H21,H30,H32)","v":0},{"$f":"IF(OR(ISBLANK(C42),ISBLANK(D42)),\"-\",IF(AND(H12=\"NEE\",F42/G12>1),1,ROUNDDOWN(F42/G12,5)))","v":{"$error":"#DIV/0!"}},{"$f":"C42/T13","v":0},null,null,null,{"$f":"SUM(J42:L42)","v":0}]
[null,{"$f":"B13","v":" "},{"$f":"SUM(D22,D25,D33,D36)","v":0},{"$f":"SUM(E22,E25,E33,E36)","v":0},{"$f":"MAX(F22,F25,F33,F36)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H22,H25,H33,H36)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Uitslagformulier","index":1,"n_rows":94,"n_cols":16,"rows_kept":94,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,5,1,9],[30,7,30,8],[8,7,8,9],[9,7,9,9],[29,7,29,8],[17,0,17,3],[18,0,18,3],[20,0,20,3],[8,3,8,6],[9,3,9,6],[21,0,21,3],[22,0,22,3],[32,7,32,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[31,7,31,8],[2,12,2,14],[18,7,23,9],[23,0,23,3],[24,0,24,3],[24,5,24,8],[17,7,17,8]]}
[]
[null,"Uitslagformulier voorronden ",null,null,null,{"$f":"Invoerblad!F1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plaatsing "]
[null,"Bondsnr.","Naam","Gew.","Remise","Carb.","Brt.","HS.","Pnt.","Moyenne","% moy.","% carb.","Mp.","% moy.","% carb.","Rangking"]
[1,{"$f":"Invoerblad!A11","v":0},{"$f":"Invoerblad!B11","v":" "},{"$f":"Invoerblad!S23","v":0},{"$f":"Invoerblad!S29","v":0},{"$f":"Invoerblad!C41","v":0},{"$f":"Invoerblad!D41","v":0},{"$f":"Invoerblad!E41","v":0},{"$f":"Invoerblad!G41","v":0},{"$f":"Invoerblad!F41","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!H41","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I41","v":0},{"$f":"Invoerblad!J41","v":0},{"$f":"Invoerblad!K41","v":0},{"$f":"Invoerblad!L41","v":0},{"$f":"SUM(M5:O5)","v":0}]
[2,{"$f":"Invoerblad!A12","v":0},{"$f":"Invoerblad!B12","v":" "},{"$f":"Invoerblad!S24","v":0},{"$f":"Invoerblad!S30","v":0},{"$f":"Invoerblad!C42","v":0},{"$f":"Invoerblad!D42","v":0},{"$f":"Invoerblad!E42","v":0},{"$f":"Invoerblad!G42","v":0},{"$f":"Invoerblad!F42","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!H42","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I42","v":0},{"$f":"Invoerblad!J42","v":0},{"$f":"Invoerblad!K42","v":0},{"$f":"Invoerblad!L42","v":0},{"$f":"SUM(M6:O6)","v":0}]
[3,{"$f":"Invoerblad!A13","v":0},{"$f":"Invoerblad!B13","v":" "},{"$f":"Invoerblad!S25","v":0},{"$f":"Invoerblad!S31","v":0},{"$f":"Invoerblad!C43","v":0},{"$f":"Invoerblad!D43","v":0},{"$f":"Invoerblad!E43","v":0},{"$f":"Invoerblad!G43","v":0},{"$f":"Invoerblad!F43","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!H43","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I43","v":0},{"$f":"Invoerblad!J43","v":0},{"$f":"Invoerblad!K43","v":0},{"$f":"Invoerblad!L43","v":0},0]
[]
[null,null,null,"Naam vereniging",null,null,null,"Datum"]
[null,null,null,{"$f":"Invoerblad!F3","v":0},null,null,null,{"$f":"TODAY()","v":"2023-11-14"}]
[]
["DIT FORMULIER DUIDELIJK INGEVULD EN VOORZIEN VAN DE HANDTEKENING "]
[]
["VAN EEN LID VAN DE ORGANISERENDE VERENIGING           BINNEN 3 DAGEN "]
[]
["NA AFLOOP VAN DE VOORWEDSTRIJDEN TOEZENDEN OF MAILEN AAN:  "]
[null,"﻿ "]
["Met vriendelijke groet",null,null,null,null,null,null,"handtekening:"]
["Wedstrijdleider PK",null,null,null,null,null,null,{"$f":"Invoerblad!F4","v":0}]
[]
["Johan Jansink"]
["Veemarkt 11"]
["7121 AH  Aalten"]
["Tel: 0543-472292 / 06-40263789"]
["j.jansink2016@gmail.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"made by Marco Ubbink"]